Best Low Code Application Development Platform
My Organization used Oracle Application Express for many custom applications, few are open on Internet. These applications cover areas …
Starting at $0.32 OCPU per hour
View PricingOverview
What is Oracle APEX?
Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Reusability (22)9.696%
- Platform User Management (22)9.494%
- Platform Security (22)9.191%
- Drag-and-drop Interfaces (22)8.080%
Reviewer Pros & Cons
Pricing
Oracle APEX Application Development
$0.32
Cloud
OCPU per hour
Oracle Autonomous Transaction Processing - Exadata Storage
$118.40
Cloud
Terabyte storage capacity per month
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://apex.oracle.com/en/learn/gettin…
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
Application Express Demo
YouTube
EBS-APEX - Demo EBS Extensions Using APEX Applications
YouTube
Introduction to Oracle Application Express (APEX) Tutorial
YouTube
Oracle Application Express
YouTube
Pharmacy Online demo built in Oracle Application Express from http://dbswh.com
YouTube
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle APEX?
Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite of pre-built productivity applications and examples, such as a Survey Builder, Bug Tracking, P-Track project management, etc
Oracle APEX Competitors
- PostgreSQL
- Microsoft
- Salesforce
Oracle APEX Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
Frequently Asked Questions
Oracle APEX (or Oracle Application Express) is an online low-code application builder that allows users to develop a database-drive application, customize the application's UI, and then give their users access to the application via URL. Oracle APEX includes a suite of pre-built productivity applications and examples, such as a Survey Builder, Bug Tracking, P-Track project management, etc
PostgreSQL are common alternatives for Oracle APEX.
Reviewers rate Visual Modeling and Reusability highest, with a score of 9.6.
The most common users of Oracle APEX are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(105)Attribute Ratings
Reviews
(1-21 of 21)Companies can't remove reviews or game the system. Here's why
September 18, 2021
Business Intelligence in Oracle APEX
Score 10 out of 10
Vetted Review
Verified User
Currently we use Oracle Application Express in only one department, but looking at how easy and fast is to add more small apps solving different tasks I believe it will be broadly adopted by a large audience very shortly.
I want to share my experience in one app we did. We are maintaining a relatively large data warehouse, design in star schema. This was used as a source for few BI tools and standard reports presenting some parts of Data Warehouse, but there was always a need for people with no SQL knowledge to get look in some part of data warehouse not presented in existing reports and tools to explore new possibilities or just to verify data. So we need some kind of simple presentation layer that quickly and easily can expose the data model and provide access to end user where they can review data in form of tables or charts. APEX look like is the perfect environment for that.
I want to share my experience in one app we did. We are maintaining a relatively large data warehouse, design in star schema. This was used as a source for few BI tools and standard reports presenting some parts of Data Warehouse, but there was always a need for people with no SQL knowledge to get look in some part of data warehouse not presented in existing reports and tools to explore new possibilities or just to verify data. So we need some kind of simple presentation layer that quickly and easily can expose the data model and provide access to end user where they can review data in form of tables or charts. APEX look like is the perfect environment for that.
Missing bit in APEX is built in functionality to define data model but that was easily solved by simple web forms where power user can define relations between fact and dimensions and store that metadata to enable dynamically SQL generation later by end users. The end users can generate dataset automatically using simple graphical interface, without the need to know SQL. Data presentation is power by a dynamically populated APEX interactive data grid. It appears that the solution was adopted by users well and we enriched it quite easily with adding functionality to organize access to app by user, roles and different permissions enabling user to share report definitions between them. This is app working internally but I created an instance of it in OCI where you can see how it works presenting a sample oracle star schema model.
https://simplebimple.com
Login with :
user: demo
pass: demo
https://simplebimple.com
Login with :
user: demo
pass: demo
- Easily create web application
- Rich , ready to use web interface components
- Easy deploy and maintain application
- Simple and powerful security configuration out of the box
- Some of the configuration options are a bit hidden, probably a bit better organization of workspace and application settings would benefit development process
At first, Oracle Application Express was used by only one department. However, after realizing the benefit, gradually it has been adopted by the whole organization. It addresses 90% of business cases, mostly on the operation and accounting side, such as building small ERP, workflow framework, tracking assets and licenses, issue tracking system, and also can be used to analyze and monitor various data, such as activity log and sales dashboard.
- Fast. Nothing beats Oracle Application Express in terms of speed of development. Almost all common and must-have features for most application has been built into Oracle Application Express, and we only need to focus to the specific requirements.
- Quality. Luckily, fast doesn't always translate to low quality. Even using basic wizard, within five minutes, we can build a quality application that has good security, a good user interface and good features, and this can be a very good standard for a company. It's not the best, but it's easy to tweak to achieve higher than standard quality.
- Customization. The apps created are very customizable. You only need to understand Oracle SQL and PL/SQL, Javascript, and JQuery. Then, you can create nearly any application you have in mind.
- Prototyping. When we are working for a client, sometimes it's hard to be on the same page when at first we only talk about the application concept. Using Oracle Application Express helps to create a prototype application and adjust it according to the client's input within minutes. This greatly helps bringing IT and non-IT clients on the same page faster.
- It's tied up to Oracle Database only. If you don't have Oracle Database, forget Oracle Application Express.
- I wish it has offline mode so it could be used in no-internet areas and sync it when it's back online.
- It's not critical, but it would be nice if there were more choices of themes. I know Oracle Application Express has couple of themes, but in my opinion, currently only Universal Theme is the theme for Oracle Application Express.
Oracle Application Express is being used by IT engineers. They build reports and small applications for our users in other departments, especially the marketing and financial departments.
- Easy to use.
- Easy to configure.
- Easy for building reports.
- Easy for building forms.
November 13, 2019
Quick development and deployment for simple apps!
Right now I created a small app to track pending/ongoing tasks using APEX on the newly available Oracle Cloud Free Tier. I decided to create it to simplify how I manage and execute my daily tasks in order to be able to both track advance and manage dependencies between tasks. I use Trello to keep boards with simple tasks but managing dependencies was something not simple to achieve, so I decided to try a solution that solved my problems while starting to use APEX.
- The UI is very easy to use, and you can choose from a number of templates for each "screen" you design.
- You can design basic CRUD screens without knowing the "details" (technology) under the hood.
- It's easy to test. Just one click, and the page you are working on is executed.
- Deployment on an OnPremise DB is not so simple. You need to follow many steps (that's why I used the Cloud version!).
August 15, 2019
Oracle APEX, build with love
Oracle Application Express is used across the whole organization. We have a lot of simple report applications we use it for (A translation app, an administration app, and a lot more).
- Easy to learn and to understand.
- Low code. You can create really fast reports with just " SELECT * FROM TABLE".
- People can work on reports simultaneously.
- In Excel, you have to send the file via mail to other people and only one person can work it. Sometimes there are more than one version of this file. With Oracle, this does not happen.
- Sorry but there are still no cons!
August 07, 2019
Be a Rock Star Developer with Oracle RAD Stack
LeeSar began using Oracle Application Express version 3.x in 2011 initially primarily for reporting, dashboarding, graphing in support of data warehouse/conversion processes toward migrating to more modern Oracle based systems supporting core operations. Since multiple applications have been created from small ancillary gap oriented to ones used across the whole organization supporting day-to-day mission critical business operations.
- Oracle Application Express is tightly integrated with and thus leverages all the richness and power of the Oracle database - best RDBMS on the planet
- Promotes declarative Rapid Application Development and thus provides tremendous business value by shortening development cycles
- Can't think of any - the Application Express development team does a fantastic job adopting and supporting emerging trends with each new release.
- Requires Oracle RDBMS; i.e., is not portable to other RDBMS platforms. On the surface this may seem like a con but it is as it should be - Oracle database is best RDBMS available and tight integration with Oracle RDBMS promotes creation of reliable performant apps.
August 07, 2019
Oracle APEX or Oracle Climax?
We use Oracle APEX in production in over 10 applications across the whole organization. It has been implemented to serve various functions, from the web portal to the ticketing system. Calendar, business white and yellow pages, web portal, asset management, IT HelpDesk and ServiceDesk (ITIL) ticketing system, car reservations application, halls and rooms reservations application and more.
- Extreme fast application build and production.
- Single sign-on via multiple authentication sources.
- Easy to maintain.
- Easy to administer users.
- Easy to administer authorizations.
- Debugging on several layers.
- Virtually everything is customizable.
- Better CSS editing (WYSIWYG).
- integrated URL masking or better integration via ORDS to make URL masking.
- out-of-the-box ORDS load-balancing.
Oracle APEX is used throughout the company on different levels. Within the company, APEX is used as a back-office management system, like registration of hours and billing. But also as a communication tool: the company news is spread through an APEX application. APEX is also used as one of the main tools to develop applications for our customers.
- APEX is incorporated in the database, which gives it better performance then other tools.
- Fast in implementing changes.
- Out-of-the-box responsive applications thanks to the universal theme.
- When you have an highly customized application upgrading can be a pain.
- Single page applications are hard to build.
July 19, 2019
Very satisfied with APEX
I'm developing a new APEX application in order to cancel previous Oracle Forms applications and integrate some functionalities of another PHP application, to give users only one instrument.
- Charts
- Loading Excel files
- Interactive reports and interactive grid
- Automate email sending
- Improve LOV features so that it could be more flexible
July 18, 2019
Honest, enthusiastic and right on the point!
Oracle Application Express is the best solution for most customers I was working with over the last couple of years. If you need to create fast and intuitive applications for creating, editing or manipulating data in your Oracle Database - APEX is your tool to go with! Inside our consulting company, we're using APEX for vacation requests, travel requests and some service applications.
- Rapid prototyping enables us to develop very fast.
- Low code allows us to create applications in a declarative way without too much code written.
- It's free!
- You need to find ways to fulfill special customer requests that are not built in and a little bit more complex.
- You need to have a running Oracle Database (possibly licensed if not XE).
January 28, 2019
Using Oracle APEX is the way to go
Score 9 out of 10
Vetted Review
Verified User
In our company we use APEX as the frontend application for our custom ERP system. In the old days we used Oracle Forms/Designer as our application. Nowadays we are migrating the Forms to APEX step by step, because we want to modernize the applications.
- Development is done quickly. Any change to the application can be seen immediately. No generation time needed.
- Compared to Oracle Forms/Designer this saves a lot of time.
- The use of CSS and javascript to beautify the layout is easy.
- There is a large community where you can ask questions or read about how other developerS solved certain issues.
- Also the Oracle APEX team itself can be reached quite easily.
- They listen carefully to the suggestions of their users.
- As you have a lot of freedom where to put your code or how you code it, it is important to think well about standarisation.
- Version control must be done in a separate tool like Subversion.
November 06, 2018
Oracle - Recommended for Professionals Like You
My company uses it for an employee tracking and data analysis system. HR has main access to all employees, with other managers having limited access to just their direct reports. We also use it for compensation analysis and reporting. I also use it to ensure that those employees who are listed as active and are not paid are either put in a leave status or terminated.
- Organization - it helps streamline employee information.
- User-friendly - very simple to use once you are trained on it.
- Timely - system works quickly and efficiently.
- Reporting - you have to use a certain code to run reports, and the reports will fail if you don't use the proper coding when requesting them.
- System crashes - our server goes down once or twice a week.
- Searching for employees - we can only search by last name, and sometimes it does not recognize the name the first time you enter it.
November 06, 2018
Oracle APEX: A quick tool for building responsive Web pages
We used Oracle Application Express for the improvements of our Business.The tool is being used in several departments to access different systems. The use of Oracle APEX has replaced use of paper-based and spreadsheet-based checking of data on a day to day basis.
- Oracle APEX can be used as good replacement for Excel data entry sheets.
- It provides high level of security about their personal information.
- It is very easy to install.
- As it is Oracle-specific, it is not suitable for other databases.
- Everything is stored online, if there is no internet we can't access the tool.
October 26, 2018
APEX: A versatile development platform, ideal for developing or improving applications at low cost
We are using APEX to develop extensions and improvements for our ERP, eBusiness Suite. The functionality developed with these tools is being used in different departments, including production, quality, reception of raw materials, etc. For instance, we have developed data entry forms, quick reports, functionality to declare industrial production, among other things.
- It is an easy tool to adopt, which allowed us to replace developments in Oracle Forms in many cases.
- It is very simple to develop different kinds of analysis, in a faster and more friendly way than running Oracle Reports.
- It helped us to extend our approval workflow, in order to cope with difficult branches that were hard to solve with the standard workflow.
- It was possible to develop web applications, to share information and transactions with our commercial partners.
- Perhaps is our problem, since we haven’t explored it deeply, but I think that a better portability to mobile devices would help the adoption of APEX.
- Applications weren’t as light as we thought, and we had to move the APEX server to the same data center where our data base was running, due to performance issues. When we started, we supposed that that situation would not be an issue.
- At least in Argentina and Brazil, you can not find as many programmers with experience in APEX as you can find with other technologies.
September 13, 2018
APEX? Live happy, deploy happy!
We use APEX for internal applications that provide services to users within the institution.
We used APEX to implement systems that would solve the problems, for example, lack of internal controls, lack of indicators that show the amount of work performed through informal requests by email or phone calls.
Due to the high level of requests, a web tool was chosen to allow the design, development, and deployment of applications quickly and agilely. Without incurring excessive licensing costs, we take advantage of the fact that APEX is a tool that is part of the internal Oracle database engine, so its use does not imply any extra cost than what we currently pay for support.
- It's free: it can be used with the different versions of the ORACLE database including the Express Edition.
- It has authentication and authorization features within the development environment, which is totally web.
- High availability in environments with Oracle RAC.
- Installation and configuration of APEX are simple.
- No extensive programming experience is required, the interface is very intuitive and there is a lot of information on the web and on the official site of Oracle.
- It allows exporting interactive reports to different formats: PPT, PDF, HTML, among others. The ability to include graphs for the dashboard simulation is very attractive and quite complete, up to the level of simulating a drill-down, by clicking on a portion of the graph to redirect to a detail table.
- Developing collaboratively can be a challenge because there is no version at the level of pages or applications.
- There is an opportunity for improvement in the way data is exported from the interactive report to PowerPoint format.
- Improve the way to optimize the performance of the application in the database separately from the engine.
June 28, 2018
APEX can do it for you!
We have an APEX application that serves the entire research administration organization across the UC Berkeley campus. Contracts and grants funding projections are created in APEX. The application pulls data from our HR system, to assist users with creating accurate projections. It automatically calculates benefits on personnel and indirect cost recovery. It saves TONS of time over the Excel projection models of the past. The data is viewable instantly in OBIEE reports.
- Allow you to use data from your Oracle Database to pre-fill forms or reports.
- It allows you to write data back to the Oracle Database.
- It is extremely fast! We have over 100 concurrent users in our APEX application and never get complaints about performance.
- It is highly configurable and can be used to create all kinds of different applications.
- You can only use APEX if you own Oracle Database.
We started using Oracle APEX as a quick means of getting a user application platform up and running once we switched to a more robust database system. Our department was the one to set it up and implement it; though, it was being used across the entire organization to access the different systems we had.
- Very easy to create a dashboard-like app platform with minimal coding knowledge.
- Implementation went off without any issues and the connected systems worked very well.
- Users can create their own reports very easily.
- While we were transitioning to more Oracle based services, we did find that APEX was locked to only Oracle products. So if you are not fully committed, it will have limited functionality.
- No version control and so make sure to keep communication open between developers.
March 26, 2018
Best tool to build web application
It helps us to develop web-based applications for users. We make mobile and window applications using this tool.
- Easy to build web-based application as we need to write less code.
- It provides an attractive user interface to build database queries.
- It provides high-level security which means never worry about their personal info.
- It should increase the perfomance as we face performance issues while using dynamic files.
- It should return instant results so that resubmiting a page can be avoided.
- There are many steps required to find out the actual issue in the code.
January 12, 2018
Quick notes on why I like Oracle Apex
Its used for business information reporting and for application development. Its used across the whole organization and was adopted to provide a fast flexible solution for information reporting. It has replaced paper-based and spreadsheet-based checking of business data on a regular daily basis. Its also being used to replace 3rd party software - for example a complaints management system.
- Enables fast application development and can be used by all levels of developer from novice to advanced
- Produces good looking, intuitive responsive web applications that are easy for the end user to understand and use
- It's in the database so can leverage all the power and functionality already there in Oracle.
- Improvements are being made all the time. Some more documentation of javascript APIs is in the next release - this will be useful
- Increased range of charts and diagrams would be good but it is already possible to do these using Oracle Jet with a bit of effort using javascript.
Oracle Application Express or APEX is a nice front end tool that comes along with your Oracle Enterprise server license. What you need is to install and configure APEX. In my previous work place there was a need for a reporting solution with the ability to have writable reports. Meaning users will see the report and can adjust/change few metrics and data elements. APEX is a great solution that can give a quick and easy to use powerful interface to create data entry form+report. In simple words you have a database table in Oracle and you want it to be exposed to users for reading and editing, Apex can do that. In the current organization i have used this tool to move away from individual Excel spreadsheets to centralized database tables.
- APEX can help you create complex and powerful reports and drill downs along with the ability to Edit the data on the fly.
- APEX can be a good replacement for Excel data entry sheets, providing centralized access to table data with authentication.
- Data entry forms with validations and triggers can be created using your existing Oracle infrastructure, easy to implement and deploy.
- APEX is a tool that can combine data entry forms and reporting (parent/ child ) using the Oracle tables in your database.
- Users get the ability to make changes to the forms data in Apex and commit, get to the report page and see the changes in real time.
- For complex APEX applications you need to be a pro expert in PL/SQL
- Debugging in APEX can be complicated if there is a logical error. Syntax errors will end up shown as ORA errors
- Lack of designer interface. Even though you are designing a form you need to do it by means of APEX interface using a series of steps, no UI for design
- Oracle specific not applicable for other databases
August 18, 2017
Oracle Application Express (ApEx) Analysis
Oracle Application Express, or ApEx, is a web interface offered for free by Oracle (is included in the database) to interact through a browser with other applications, Oracle or not. In my company, I work as a business intelligence consultant by developing with Oracle back-end tools (like Oracle Database, Oracle Data Integrator, FDMEE), and I've had many occasions of seeing the potentialities of Oracle Application Express.
Thanks to its versatility, ApEx is able to solve many kinds of business problems, like - small reporting, through the implementations of simple and navigable reports; - database writing, through many kinds of forms; - web-service (Oracle and non) invocations; - creating charts and data based diagrams. ApEx is a really flexible tool that can interact with many different technologies, has a lot of plugins and is fully accessible from a browser, both from a desktop platform and from mobile.
Thanks to its versatility, ApEx is able to solve many kinds of business problems, like - small reporting, through the implementations of simple and navigable reports; - database writing, through many kinds of forms; - web-service (Oracle and non) invocations; - creating charts and data based diagrams. ApEx is a really flexible tool that can interact with many different technologies, has a lot of plugins and is fully accessible from a browser, both from a desktop platform and from mobile.
- Installation included for free with Oracle Database
- Easy to access from a browser, both from desktop and from mobile
- Simple web based interface for development
- Easy to learn, with a good variety of functionalities already implemented and customizable
- Able to interact with Oracle back-end technologies and with many third parties web tools
- Sometimes it is so simple that it doesn't offer the desired functionality
- At the beginning it may be a bit difficult to work with the customizations required starting from the basic applications offered inside the installation
- It may be difficult to insert "advanced" customizations on the page (eg: web scripting for effects or popups)